UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'hoFR6sLeNIVMJN/pN1MxizzgWsbKaPpSSW3/YSLEDR0='
WHERE
key_id = '883b8d580e4e8b2de4437d80a87427ef78572cedf4cf94e80fc923667ce106ee'
AND (
token = 'hoFR6sLeNIVMJN/pN1MxizzgWsbKaPpSSW3/YSLEDR0='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)