UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'UCTLo5HOLTY9RA2K3FtJ67E6q5s5EF20OG12pf9osbM='
WHERE
key_id = '1463d20db0f2894eba6c75ce118a65b0af71f5489f665f1ef22278453ecf1fa9'
AND (
token = 'UCTLo5HOLTY9RA2K3FtJ67E6q5s5EF20OG12pf9osbM='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)