UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'NJlQZ5xtq4giz50rIPz7ULE6mJdnMh1RwkCtshoA2C0='
WHERE
key_id = '21486d25d7d027bb83fb20890586c51888c38c28606435f2aa8ff300dd0b1a20'
AND (
token = 'NJlQZ5xtq4giz50rIPz7ULE6mJdnMh1RwkCtshoA2C0='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)