UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'jZXzLezfD4SbrxLo4fvR0krbcRN9Yiob+1MqVJA4KtI='
WHERE
key_id = 'e914f1a70ca9ee4179c9c70016e3d37751929a55ae0c2e95724ace688484eff2'
AND (
token = 'jZXzLezfD4SbrxLo4fvR0krbcRN9Yiob+1MqVJA4KtI='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)