UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'ZjY1VeGbDkeNpkcZ2Ac2yCYIbZJzajUC830/gxrwRQA='
WHERE
key_id = '505fa1697e4309281e29621b69a95e8bc1d0cf222bb523234056de1542e0e685'
AND (
token = 'ZjY1VeGbDkeNpkcZ2Ac2yCYIbZJzajUC830/gxrwRQA='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)