UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = '42SSpj3FV8nzIZCo4sJGFoTLg9omtE+BLe4/Iwgzqng='
WHERE
key_id = '28b80b280150637bea425d5e11bd634aa0f0dee943a5f4b966264fe867f123c1'
AND (
token = '42SSpj3FV8nzIZCo4sJGFoTLg9omtE+BLe4/Iwgzqng='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)