UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'eS0ag3186LVYf31XpMAYGZxrmU4tceOaUI138Zd/2SA='
WHERE
key_id = '7a9e03a4c397acf760efac1d0139e208373a5efb202a97a379900b94930c97ab'
AND (
token = 'eS0ag3186LVYf31XpMAYGZxrmU4tceOaUI138Zd/2SA='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)