UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'i1FGt8PmzehYYUKsroc1ksK1hxDXIg0qnVWnpMhGG8o='
WHERE
key_id = 'ac69b319f92a5a0c547dc2643a63cd2fb2c8d99758ad6e1c182edc40d3d38377'
AND (
token = 'i1FGt8PmzehYYUKsroc1ksK1hxDXIg0qnVWnpMhGG8o='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)