UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = '4TVMmNewSWXk7+nmirfL3gHq+4nfLbzi+yTA0h8UsPA='
WHERE
key_id = '47cfa861032e6a7171f9c10f9bd12acc5bcce0ecf54e8609cb4af24427d62abe'
AND (
token = '4TVMmNewSWXk7+nmirfL3gHq+4nfLbzi+yTA0h8UsPA='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)