UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'TIQ5XwMHGQxr8NDpSXgc1deuNm1PfAeN1DNxE1cZDzo='
WHERE
key_id = 'a9e41924454fc2b18715828c45d0e6814c80129fbe10457e6cf27794489da8ad'
AND (
token = 'TIQ5XwMHGQxr8NDpSXgc1deuNm1PfAeN1DNxE1cZDzo='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)