UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'zD2NkYv2Lk/4GsHvY9hASjCLwxpxWg6pmq4PPTsQ4uw='
WHERE
key_id = 'bf65a50d2568874b751cf20b4c3cb12040f6a41380df3fbeec6e0783fb9f2d7b'
AND (
token = 'zD2NkYv2Lk/4GsHvY9hASjCLwxpxWg6pmq4PPTsQ4uw='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)