UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'BOMcCdmwGYtingZ5vC1I07p8lWw1EFAIoqJY9F8BFUg='
WHERE
key_id = '59634ea2c09492b404ef1d8401e57988a1bf2cc97b9d3a748d98ed8180425256'
AND (
token = 'BOMcCdmwGYtingZ5vC1I07p8lWw1EFAIoqJY9F8BFUg='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)