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