UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'PXHIxhykLdMM2Tx/ESYNyWbzd0O5LEcRD7daUqMf8G0='
WHERE
key_id = '7abfe4eee8968b32f27278a486f4c795203b1388e992b4d1d540b27382b0166c'
AND (
token = 'PXHIxhykLdMM2Tx/ESYNyWbzd0O5LEcRD7daUqMf8G0='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)