UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'lOpgxuaLBC7UbYEnZ7NIQCtopgWD3Vt3ufWg71/vL/k='
WHERE
key_id = '3b016069f6afaab814b3484f8e7f5dd66ecad4bbb7b7cd4a2885c80f3fba6077'
AND (
token = 'lOpgxuaLBC7UbYEnZ7NIQCtopgWD3Vt3ufWg71/vL/k='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)