UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'ggvSqOHNekb40LRrXA8qpWMeeLKitXJZkX+ipYH9nRE='
WHERE
key_id = '4f1c86468672449c8da2e78008ef99f8959810d7b27600d60e6ed7f99cfb8bed'
AND (
token = 'ggvSqOHNekb40LRrXA8qpWMeeLKitXJZkX+ipYH9nRE='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)