UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'HTjjKRlxYloGScsXf0RyBHSMG6qgQfNzQ76VnWk2xHQ='
WHERE
key_id = 'dcc179f53903297e3938ae9666f0bbb132ce4e45f42074779cdfbb0d99d12fbb'
AND (
token = 'HTjjKRlxYloGScsXf0RyBHSMG6qgQfNzQ76VnWk2xHQ='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)