UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = '6Z1QYgqY1i0lX31rk4V3TXOjXqrfED80D3uwN+AKiUA='
WHERE
key_id = '2dc9aa56b2915ce0133235213e6bbfe94bdf8e18f10f2b162c2e267469f0ee33'
AND (
token = '6Z1QYgqY1i0lX31rk4V3TXOjXqrfED80D3uwN+AKiUA='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)