UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'z86SzWTxFrBxYLBRfluBWOrZA/9+Isx+AWtSD6TKWS8='
WHERE
key_id = 'f043bafd11f7439ae315a5a3d43c33d145451785a6a28f8f2933c93dc06f8530'
AND (
token = 'z86SzWTxFrBxYLBRfluBWOrZA/9+Isx+AWtSD6TKWS8='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)