UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'jpfhWhrOVARZzT8z8H4343C5QFoAReoYRwJTqUqvNTM='
WHERE
key_id = '579cb6b4f2366b7215b767409fbafe267b79a1ea76eef215b24eae3d0165501a'
AND (
token = 'jpfhWhrOVARZzT8z8H4343C5QFoAReoYRwJTqUqvNTM='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)