UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'lkZzsr9HceVX3ide62H8bCiY3hDc6Rwe87nNM7vb24s='
WHERE
key_id = '3dc25b49c39199ca01b572e2755f51e1fa3cd8fd157ad99b82189a6a2cf6308e'
AND (
token = 'lkZzsr9HceVX3ide62H8bCiY3hDc6Rwe87nNM7vb24s='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)