UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'gG1kbHl4BG26KmCZu4BvW/STP1hZxlNa0hyTJq3fREw='
WHERE
key_id = 'f47bc93bdefc3a8809b55fb8f9121764f7653d044c92d8d6e2a375203501b78f'
AND (
token = 'gG1kbHl4BG26KmCZu4BvW/STP1hZxlNa0hyTJq3fREw='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)