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