UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'g8Fu2WFiY61I8FzoTOsp8+3v3g64QSm34ePwDft5/eo='
WHERE
key_id = 'b904f343f81b832b2a51938f3f6028b1913515efde3e1d72952beb4dcc24ca9e'
AND (
token = 'g8Fu2WFiY61I8FzoTOsp8+3v3g64QSm34ePwDft5/eo='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)