UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'S5wD2nQKCSlRQEmtACE941nHmNzvpHbdfJPaQZYHqF8='
WHERE
key_id = '4e16229bc6878df4a1ea2f52669a178f7381a4d9ef93814c4afecace7708f021'
AND (
token = 'S5wD2nQKCSlRQEmtACE941nHmNzvpHbdfJPaQZYHqF8='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)