UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = '9l22Y1EHW92hh4JIgxMnsyAbZBE+65VCRrKyMN8T8U0='
WHERE
key_id = '22d0ed8b262ee4989ba9fb4a530dcc7a057589137c2ea0a1d2f9655f1894174a'
AND (
token = '9l22Y1EHW92hh4JIgxMnsyAbZBE+65VCRrKyMN8T8U0='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)