UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'ygLv9rUt6LL25/rArB1B67gcgzUskUku36ea/N6gaLg='
WHERE
key_id = '7f593c5c98f023b760464a823f166cb29a73ab2092fac2884578bdac4daae659'
AND (
token = 'ygLv9rUt6LL25/rArB1B67gcgzUskUku36ea/N6gaLg='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)