UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'sl9iDLUzRxqgiGEeVrKguVWKGobjwVr3svJzW5LD8l4='
WHERE
key_id = '8042e23bae676ec5ea0064a7f771f08136783d33b8c41cd9f29c7f5135b2a6a0'
AND (
token = 'sl9iDLUzRxqgiGEeVrKguVWKGobjwVr3svJzW5LD8l4='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)