UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'BC5gKdou+1X9NfRWzIqvgsfISymU9bTlb+p3Zl/FHNw='
WHERE
key_id = 'e21cd65a542cf9e2e9c116b33b5199eb5cbc0e61d8d9b72ccf82e6251ccdc124'
AND (
token = 'BC5gKdou+1X9NfRWzIqvgsfISymU9bTlb+p3Zl/FHNw='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)