UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'HpYS9AIH+bM1Q00hC8gaSj7BwfY7pkliY5nhANReTKk='
WHERE
key_id = '9e9693b464c982e7832148f6f576680e8ebe5e551c3292fe5d92271731a1525f'
AND (
token = 'HpYS9AIH+bM1Q00hC8gaSj7BwfY7pkliY5nhANReTKk='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)