UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'Ha8955XdzLVmHDdGDmvamjiskr7dnaK5Uh0751jjfWg='
WHERE
key_id = '6d8fbaa29b8818728d234d1b7df892b26e0409f4413de8918c748caebc2768a3'
AND (
token = 'Ha8955XdzLVmHDdGDmvamjiskr7dnaK5Uh0751jjfWg='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)