UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = '1W2byjz1NNp4woUj07rodgT8boHagFuDWaPoURXkzUs='
WHERE
key_id = 'd1e3d9e2b3f107202a72f41d75e36be5ebda1a31b22576d6ead8c6864c387f0d'
AND (
token = '1W2byjz1NNp4woUj07rodgT8boHagFuDWaPoURXkzUs='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)